/**
 * User: 蕨菜
 * Date: 2019-05-22
 * Time: 14:27
 * Description: 此文件简要说明
 */

module.exports = function (sequelize, dataTypes) {
    return sequelize.define('score', {
        id: {
            type: dataTypes.BIGINT(11),
            allowNull: false,
            primaryKey: true,
            autoIncrement: true,
            unique: true,
            comment: '分数id',
        },
        date: {
            type: dataTypes.DATE,
            allowNull: false,
            comment: '成绩对应的年月份'
        },
        chinese: {
            type: dataTypes.BIGINT(3),
            allowNull: false,
            comment: '语文成绩'
        },
        math: {
            type: dataTypes.BIGINT(3),
            allowNull: false,
            comment: '数学成绩'
        },
        english: {
            type: dataTypes.BIGINT(3),
            allowNull: false,
            comment: '英语成绩'
        },
        physical: {
            type: dataTypes.BIGINT(3),
            allowNull: false,
            comment: '物理成绩'
        },
        chemistry: {
            type: dataTypes.BIGINT(3),
            allowNull: false,
            comment: '化学成绩'
        },
        biological: {
            type: dataTypes.BIGINT(3),
            allowNull: false,
            comment: '生物成绩'
        },
        political: {
            type: dataTypes.BIGINT(3),
            allowNull: false,
            comment: '政治成绩'
        },
        history: {
            type: dataTypes.BIGINT(3),
            allowNull: false,
            comment: '历史成绩'
        },
        geography: {
            type: dataTypes.BIGINT(3),
            allowNull: false,
            comment: '地理成绩'
        },

        active: {
            type: dataTypes.BOOLEAN,
            allowNull: false,
            comment: '是否处于激活状态'
        }
    })
}